package cn.ticket.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import cn.ticket.model.Routes;
@Repository 
@Transactional
public interface RoutesMapper {
    int deleteByPrimaryKey(Short id);

    int insert(Routes record);

    int insertSelective(Routes record);

    Routes selectByPrimaryKey(Short id);

    int updateByPrimaryKeySelective(Routes record);

    int updateByPrimaryKey(Routes record);
    
    List<Routes> getAll();
    
    List<Routes> getByIdLimit(@Param("startId")Integer startId,@Param("endId")Integer endId);
    
    List<Routes> getByOrientation(@Param("orientation")String orientation);
}